package com.angel.health;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class BuzCustomerExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BuzCustomerExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("code is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("code is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("code =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("code <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("code >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("code >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("code <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("code <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("code like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("code not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("code in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("code not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("code between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("code not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andFamilyIdIsNull() {
            addCriterion("family_id is null");
            return (Criteria) this;
        }

        public Criteria andFamilyIdIsNotNull() {
            addCriterion("family_id is not null");
            return (Criteria) this;
        }

        public Criteria andFamilyIdEqualTo(Integer value) {
            addCriterion("family_id =", value, "familyId");
            return (Criteria) this;
        }

        public Criteria andFamilyIdNotEqualTo(Integer value) {
            addCriterion("family_id <>", value, "familyId");
            return (Criteria) this;
        }

        public Criteria andFamilyIdGreaterThan(Integer value) {
            addCriterion("family_id >", value, "familyId");
            return (Criteria) this;
        }

        public Criteria andFamilyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("family_id >=", value, "familyId");
            return (Criteria) this;
        }

        public Criteria andFamilyIdLessThan(Integer value) {
            addCriterion("family_id <", value, "familyId");
            return (Criteria) this;
        }

        public Criteria andFamilyIdLessThanOrEqualTo(Integer value) {
            addCriterion("family_id <=", value, "familyId");
            return (Criteria) this;
        }

        public Criteria andFamilyIdIn(List<Integer> values) {
            addCriterion("family_id in", values, "familyId");
            return (Criteria) this;
        }

        public Criteria andFamilyIdNotIn(List<Integer> values) {
            addCriterion("family_id not in", values, "familyId");
            return (Criteria) this;
        }

        public Criteria andFamilyIdBetween(Integer value1, Integer value2) {
            addCriterion("family_id between", value1, value2, "familyId");
            return (Criteria) this;
        }

        public Criteria andFamilyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("family_id not between", value1, value2, "familyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNull() {
            addCriterion("company_id is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNotNull() {
            addCriterion("company_id is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdEqualTo(Integer value) {
            addCriterion("company_id =", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotEqualTo(Integer value) {
            addCriterion("company_id <>", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThan(Integer value) {
            addCriterion("company_id >", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("company_id >=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThan(Integer value) {
            addCriterion("company_id <", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThanOrEqualTo(Integer value) {
            addCriterion("company_id <=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIn(List<Integer> values) {
            addCriterion("company_id in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotIn(List<Integer> values) {
            addCriterion("company_id not in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdBetween(Integer value1, Integer value2) {
            addCriterion("company_id between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("company_id not between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andLabelIdIsNull() {
            addCriterion("label_id is null");
            return (Criteria) this;
        }

        public Criteria andLabelIdIsNotNull() {
            addCriterion("label_id is not null");
            return (Criteria) this;
        }

        public Criteria andLabelIdEqualTo(Integer value) {
            addCriterion("label_id =", value, "labelId");
            return (Criteria) this;
        }

        public Criteria andLabelIdNotEqualTo(Integer value) {
            addCriterion("label_id <>", value, "labelId");
            return (Criteria) this;
        }

        public Criteria andLabelIdGreaterThan(Integer value) {
            addCriterion("label_id >", value, "labelId");
            return (Criteria) this;
        }

        public Criteria andLabelIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("label_id >=", value, "labelId");
            return (Criteria) this;
        }

        public Criteria andLabelIdLessThan(Integer value) {
            addCriterion("label_id <", value, "labelId");
            return (Criteria) this;
        }

        public Criteria andLabelIdLessThanOrEqualTo(Integer value) {
            addCriterion("label_id <=", value, "labelId");
            return (Criteria) this;
        }

        public Criteria andLabelIdIn(List<Integer> values) {
            addCriterion("label_id in", values, "labelId");
            return (Criteria) this;
        }

        public Criteria andLabelIdNotIn(List<Integer> values) {
            addCriterion("label_id not in", values, "labelId");
            return (Criteria) this;
        }

        public Criteria andLabelIdBetween(Integer value1, Integer value2) {
            addCriterion("label_id between", value1, value2, "labelId");
            return (Criteria) this;
        }

        public Criteria andLabelIdNotBetween(Integer value1, Integer value2) {
            addCriterion("label_id not between", value1, value2, "labelId");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andMemPhoneIsNull() {
            addCriterion("mem_phone is null");
            return (Criteria) this;
        }

        public Criteria andMemPhoneIsNotNull() {
            addCriterion("mem_phone is not null");
            return (Criteria) this;
        }

        public Criteria andMemPhoneEqualTo(String value) {
            addCriterion("mem_phone =", value, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneNotEqualTo(String value) {
            addCriterion("mem_phone <>", value, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneGreaterThan(String value) {
            addCriterion("mem_phone >", value, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("mem_phone >=", value, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneLessThan(String value) {
            addCriterion("mem_phone <", value, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneLessThanOrEqualTo(String value) {
            addCriterion("mem_phone <=", value, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneLike(String value) {
            addCriterion("mem_phone like", value, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneNotLike(String value) {
            addCriterion("mem_phone not like", value, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneIn(List<String> values) {
            addCriterion("mem_phone in", values, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneNotIn(List<String> values) {
            addCriterion("mem_phone not in", values, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneBetween(String value1, String value2) {
            addCriterion("mem_phone between", value1, value2, "memPhone");
            return (Criteria) this;
        }

        public Criteria andMemPhoneNotBetween(String value1, String value2) {
            addCriterion("mem_phone not between", value1, value2, "memPhone");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeIsNull() {
            addCriterion("certificate_type is null");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeIsNotNull() {
            addCriterion("certificate_type is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeEqualTo(Integer value) {
            addCriterion("certificate_type =", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotEqualTo(Integer value) {
            addCriterion("certificate_type <>", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeGreaterThan(Integer value) {
            addCriterion("certificate_type >", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("certificate_type >=", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeLessThan(Integer value) {
            addCriterion("certificate_type <", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeLessThanOrEqualTo(Integer value) {
            addCriterion("certificate_type <=", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeIn(List<Integer> values) {
            addCriterion("certificate_type in", values, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotIn(List<Integer> values) {
            addCriterion("certificate_type not in", values, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeBetween(Integer value1, Integer value2) {
            addCriterion("certificate_type between", value1, value2, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("certificate_type not between", value1, value2, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCardNumberIsNull() {
            addCriterion("card_number is null");
            return (Criteria) this;
        }

        public Criteria andCardNumberIsNotNull() {
            addCriterion("card_number is not null");
            return (Criteria) this;
        }

        public Criteria andCardNumberEqualTo(String value) {
            addCriterion("card_number =", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberNotEqualTo(String value) {
            addCriterion("card_number <>", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberGreaterThan(String value) {
            addCriterion("card_number >", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberGreaterThanOrEqualTo(String value) {
            addCriterion("card_number >=", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberLessThan(String value) {
            addCriterion("card_number <", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberLessThanOrEqualTo(String value) {
            addCriterion("card_number <=", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberLike(String value) {
            addCriterion("card_number like", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberNotLike(String value) {
            addCriterion("card_number not like", value, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberIn(List<String> values) {
            addCriterion("card_number in", values, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberNotIn(List<String> values) {
            addCriterion("card_number not in", values, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberBetween(String value1, String value2) {
            addCriterion("card_number between", value1, value2, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andCardNumberNotBetween(String value1, String value2) {
            addCriterion("card_number not between", value1, value2, "cardNumber");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNull() {
            addCriterion("birthday is null");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNotNull() {
            addCriterion("birthday is not null");
            return (Criteria) this;
        }

        public Criteria andBirthdayEqualTo(String value) {
            addCriterion("birthday =", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotEqualTo(String value) {
            addCriterion("birthday <>", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThan(String value) {
            addCriterion("birthday >", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThanOrEqualTo(String value) {
            addCriterion("birthday >=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThan(String value) {
            addCriterion("birthday <", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThanOrEqualTo(String value) {
            addCriterion("birthday <=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLike(String value) {
            addCriterion("birthday like", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotLike(String value) {
            addCriterion("birthday not like", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayIn(List<String> values) {
            addCriterion("birthday in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotIn(List<String> values) {
            addCriterion("birthday not in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayBetween(String value1, String value2) {
            addCriterion("birthday between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotBetween(String value1, String value2) {
            addCriterion("birthday not between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(Integer value) {
            addCriterion("sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(Integer value) {
            addCriterion("sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(Integer value) {
            addCriterion("sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(Integer value) {
            addCriterion("sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(Integer value) {
            addCriterion("sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<Integer> values) {
            addCriterion("sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<Integer> values) {
            addCriterion("sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(Integer value1, Integer value2) {
            addCriterion("sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(Integer value1, Integer value2) {
            addCriterion("sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberIsNull() {
            addCriterion("member_card_number is null");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberIsNotNull() {
            addCriterion("member_card_number is not null");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberEqualTo(String value) {
            addCriterion("member_card_number =", value, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberNotEqualTo(String value) {
            addCriterion("member_card_number <>", value, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberGreaterThan(String value) {
            addCriterion("member_card_number >", value, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberGreaterThanOrEqualTo(String value) {
            addCriterion("member_card_number >=", value, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberLessThan(String value) {
            addCriterion("member_card_number <", value, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberLessThanOrEqualTo(String value) {
            addCriterion("member_card_number <=", value, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberLike(String value) {
            addCriterion("member_card_number like", value, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberNotLike(String value) {
            addCriterion("member_card_number not like", value, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberIn(List<String> values) {
            addCriterion("member_card_number in", values, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberNotIn(List<String> values) {
            addCriterion("member_card_number not in", values, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberBetween(String value1, String value2) {
            addCriterion("member_card_number between", value1, value2, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andMemberCardNumberNotBetween(String value1, String value2) {
            addCriterion("member_card_number not between", value1, value2, "memberCardNumber");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdIsNull() {
            addCriterion("social_security_id is null");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdIsNotNull() {
            addCriterion("social_security_id is not null");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdEqualTo(String value) {
            addCriterion("social_security_id =", value, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdNotEqualTo(String value) {
            addCriterion("social_security_id <>", value, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdGreaterThan(String value) {
            addCriterion("social_security_id >", value, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdGreaterThanOrEqualTo(String value) {
            addCriterion("social_security_id >=", value, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdLessThan(String value) {
            addCriterion("social_security_id <", value, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdLessThanOrEqualTo(String value) {
            addCriterion("social_security_id <=", value, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdLike(String value) {
            addCriterion("social_security_id like", value, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdNotLike(String value) {
            addCriterion("social_security_id not like", value, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdIn(List<String> values) {
            addCriterion("social_security_id in", values, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdNotIn(List<String> values) {
            addCriterion("social_security_id not in", values, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdBetween(String value1, String value2) {
            addCriterion("social_security_id between", value1, value2, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIdNotBetween(String value1, String value2) {
            addCriterion("social_security_id not between", value1, value2, "socialSecurityId");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsIsNull() {
            addCriterion("urgent_contacts is null");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsIsNotNull() {
            addCriterion("urgent_contacts is not null");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsEqualTo(String value) {
            addCriterion("urgent_contacts =", value, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsNotEqualTo(String value) {
            addCriterion("urgent_contacts <>", value, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsGreaterThan(String value) {
            addCriterion("urgent_contacts >", value, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsGreaterThanOrEqualTo(String value) {
            addCriterion("urgent_contacts >=", value, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsLessThan(String value) {
            addCriterion("urgent_contacts <", value, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsLessThanOrEqualTo(String value) {
            addCriterion("urgent_contacts <=", value, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsLike(String value) {
            addCriterion("urgent_contacts like", value, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsNotLike(String value) {
            addCriterion("urgent_contacts not like", value, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsIn(List<String> values) {
            addCriterion("urgent_contacts in", values, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsNotIn(List<String> values) {
            addCriterion("urgent_contacts not in", values, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsBetween(String value1, String value2) {
            addCriterion("urgent_contacts between", value1, value2, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andUrgentContactsNotBetween(String value1, String value2) {
            addCriterion("urgent_contacts not between", value1, value2, "urgentContacts");
            return (Criteria) this;
        }

        public Criteria andSrgentTelIsNull() {
            addCriterion("srgent_tel is null");
            return (Criteria) this;
        }

        public Criteria andSrgentTelIsNotNull() {
            addCriterion("srgent_tel is not null");
            return (Criteria) this;
        }

        public Criteria andSrgentTelEqualTo(String value) {
            addCriterion("srgent_tel =", value, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelNotEqualTo(String value) {
            addCriterion("srgent_tel <>", value, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelGreaterThan(String value) {
            addCriterion("srgent_tel >", value, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelGreaterThanOrEqualTo(String value) {
            addCriterion("srgent_tel >=", value, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelLessThan(String value) {
            addCriterion("srgent_tel <", value, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelLessThanOrEqualTo(String value) {
            addCriterion("srgent_tel <=", value, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelLike(String value) {
            addCriterion("srgent_tel like", value, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelNotLike(String value) {
            addCriterion("srgent_tel not like", value, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelIn(List<String> values) {
            addCriterion("srgent_tel in", values, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelNotIn(List<String> values) {
            addCriterion("srgent_tel not in", values, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelBetween(String value1, String value2) {
            addCriterion("srgent_tel between", value1, value2, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andSrgentTelNotBetween(String value1, String value2) {
            addCriterion("srgent_tel not between", value1, value2, "srgentTel");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeIsNull() {
            addCriterion("highest_degree is null");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeIsNotNull() {
            addCriterion("highest_degree is not null");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeEqualTo(Integer value) {
            addCriterion("highest_degree =", value, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeNotEqualTo(Integer value) {
            addCriterion("highest_degree <>", value, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeGreaterThan(Integer value) {
            addCriterion("highest_degree >", value, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeGreaterThanOrEqualTo(Integer value) {
            addCriterion("highest_degree >=", value, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeLessThan(Integer value) {
            addCriterion("highest_degree <", value, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeLessThanOrEqualTo(Integer value) {
            addCriterion("highest_degree <=", value, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeIn(List<Integer> values) {
            addCriterion("highest_degree in", values, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeNotIn(List<Integer> values) {
            addCriterion("highest_degree not in", values, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeBetween(Integer value1, Integer value2) {
            addCriterion("highest_degree between", value1, value2, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andHighestDegreeNotBetween(Integer value1, Integer value2) {
            addCriterion("highest_degree not between", value1, value2, "highestDegree");
            return (Criteria) this;
        }

        public Criteria andBirthAddressIsNull() {
            addCriterion("birth_address is null");
            return (Criteria) this;
        }

        public Criteria andBirthAddressIsNotNull() {
            addCriterion("birth_address is not null");
            return (Criteria) this;
        }

        public Criteria andBirthAddressEqualTo(String value) {
            addCriterion("birth_address =", value, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressNotEqualTo(String value) {
            addCriterion("birth_address <>", value, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressGreaterThan(String value) {
            addCriterion("birth_address >", value, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressGreaterThanOrEqualTo(String value) {
            addCriterion("birth_address >=", value, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressLessThan(String value) {
            addCriterion("birth_address <", value, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressLessThanOrEqualTo(String value) {
            addCriterion("birth_address <=", value, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressLike(String value) {
            addCriterion("birth_address like", value, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressNotLike(String value) {
            addCriterion("birth_address not like", value, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressIn(List<String> values) {
            addCriterion("birth_address in", values, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressNotIn(List<String> values) {
            addCriterion("birth_address not in", values, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressBetween(String value1, String value2) {
            addCriterion("birth_address between", value1, value2, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressNotBetween(String value1, String value2) {
            addCriterion("birth_address not between", value1, value2, "birthAddress");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishIsNull() {
            addCriterion("birth_address_replenish is null");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishIsNotNull() {
            addCriterion("birth_address_replenish is not null");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishEqualTo(String value) {
            addCriterion("birth_address_replenish =", value, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishNotEqualTo(String value) {
            addCriterion("birth_address_replenish <>", value, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishGreaterThan(String value) {
            addCriterion("birth_address_replenish >", value, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishGreaterThanOrEqualTo(String value) {
            addCriterion("birth_address_replenish >=", value, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishLessThan(String value) {
            addCriterion("birth_address_replenish <", value, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishLessThanOrEqualTo(String value) {
            addCriterion("birth_address_replenish <=", value, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishLike(String value) {
            addCriterion("birth_address_replenish like", value, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishNotLike(String value) {
            addCriterion("birth_address_replenish not like", value, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishIn(List<String> values) {
            addCriterion("birth_address_replenish in", values, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishNotIn(List<String> values) {
            addCriterion("birth_address_replenish not in", values, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishBetween(String value1, String value2) {
            addCriterion("birth_address_replenish between", value1, value2, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andBirthAddressReplenishNotBetween(String value1, String value2) {
            addCriterion("birth_address_replenish not between", value1, value2, "birthAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andWorkIsNull() {
            addCriterion("work is null");
            return (Criteria) this;
        }

        public Criteria andWorkIsNotNull() {
            addCriterion("work is not null");
            return (Criteria) this;
        }

        public Criteria andWorkEqualTo(String value) {
            addCriterion("work =", value, "work");
            return (Criteria) this;
        }

        public Criteria andWorkNotEqualTo(String value) {
            addCriterion("work <>", value, "work");
            return (Criteria) this;
        }

        public Criteria andWorkGreaterThan(String value) {
            addCriterion("work >", value, "work");
            return (Criteria) this;
        }

        public Criteria andWorkGreaterThanOrEqualTo(String value) {
            addCriterion("work >=", value, "work");
            return (Criteria) this;
        }

        public Criteria andWorkLessThan(String value) {
            addCriterion("work <", value, "work");
            return (Criteria) this;
        }

        public Criteria andWorkLessThanOrEqualTo(String value) {
            addCriterion("work <=", value, "work");
            return (Criteria) this;
        }

        public Criteria andWorkLike(String value) {
            addCriterion("work like", value, "work");
            return (Criteria) this;
        }

        public Criteria andWorkNotLike(String value) {
            addCriterion("work not like", value, "work");
            return (Criteria) this;
        }

        public Criteria andWorkIn(List<String> values) {
            addCriterion("work in", values, "work");
            return (Criteria) this;
        }

        public Criteria andWorkNotIn(List<String> values) {
            addCriterion("work not in", values, "work");
            return (Criteria) this;
        }

        public Criteria andWorkBetween(String value1, String value2) {
            addCriterion("work between", value1, value2, "work");
            return (Criteria) this;
        }

        public Criteria andWorkNotBetween(String value1, String value2) {
            addCriterion("work not between", value1, value2, "work");
            return (Criteria) this;
        }

        public Criteria andNationalIsNull() {
            addCriterion("national is null");
            return (Criteria) this;
        }

        public Criteria andNationalIsNotNull() {
            addCriterion("national is not null");
            return (Criteria) this;
        }

        public Criteria andNationalEqualTo(String value) {
            addCriterion("national =", value, "national");
            return (Criteria) this;
        }

        public Criteria andNationalNotEqualTo(String value) {
            addCriterion("national <>", value, "national");
            return (Criteria) this;
        }

        public Criteria andNationalGreaterThan(String value) {
            addCriterion("national >", value, "national");
            return (Criteria) this;
        }

        public Criteria andNationalGreaterThanOrEqualTo(String value) {
            addCriterion("national >=", value, "national");
            return (Criteria) this;
        }

        public Criteria andNationalLessThan(String value) {
            addCriterion("national <", value, "national");
            return (Criteria) this;
        }

        public Criteria andNationalLessThanOrEqualTo(String value) {
            addCriterion("national <=", value, "national");
            return (Criteria) this;
        }

        public Criteria andNationalLike(String value) {
            addCriterion("national like", value, "national");
            return (Criteria) this;
        }

        public Criteria andNationalNotLike(String value) {
            addCriterion("national not like", value, "national");
            return (Criteria) this;
        }

        public Criteria andNationalIn(List<String> values) {
            addCriterion("national in", values, "national");
            return (Criteria) this;
        }

        public Criteria andNationalNotIn(List<String> values) {
            addCriterion("national not in", values, "national");
            return (Criteria) this;
        }

        public Criteria andNationalBetween(String value1, String value2) {
            addCriterion("national between", value1, value2, "national");
            return (Criteria) this;
        }

        public Criteria andNationalNotBetween(String value1, String value2) {
            addCriterion("national not between", value1, value2, "national");
            return (Criteria) this;
        }

        public Criteria andBloodIsNull() {
            addCriterion("blood is null");
            return (Criteria) this;
        }

        public Criteria andBloodIsNotNull() {
            addCriterion("blood is not null");
            return (Criteria) this;
        }

        public Criteria andBloodEqualTo(String value) {
            addCriterion("blood =", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodNotEqualTo(String value) {
            addCriterion("blood <>", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodGreaterThan(String value) {
            addCriterion("blood >", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodGreaterThanOrEqualTo(String value) {
            addCriterion("blood >=", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodLessThan(String value) {
            addCriterion("blood <", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodLessThanOrEqualTo(String value) {
            addCriterion("blood <=", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodLike(String value) {
            addCriterion("blood like", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodNotLike(String value) {
            addCriterion("blood not like", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodIn(List<String> values) {
            addCriterion("blood in", values, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodNotIn(List<String> values) {
            addCriterion("blood not in", values, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodBetween(String value1, String value2) {
            addCriterion("blood between", value1, value2, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodNotBetween(String value1, String value2) {
            addCriterion("blood not between", value1, value2, "blood");
            return (Criteria) this;
        }

        public Criteria andRhBloodIsNull() {
            addCriterion("rh_blood is null");
            return (Criteria) this;
        }

        public Criteria andRhBloodIsNotNull() {
            addCriterion("rh_blood is not null");
            return (Criteria) this;
        }

        public Criteria andRhBloodEqualTo(Integer value) {
            addCriterion("rh_blood =", value, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andRhBloodNotEqualTo(Integer value) {
            addCriterion("rh_blood <>", value, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andRhBloodGreaterThan(Integer value) {
            addCriterion("rh_blood >", value, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andRhBloodGreaterThanOrEqualTo(Integer value) {
            addCriterion("rh_blood >=", value, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andRhBloodLessThan(Integer value) {
            addCriterion("rh_blood <", value, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andRhBloodLessThanOrEqualTo(Integer value) {
            addCriterion("rh_blood <=", value, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andRhBloodIn(List<Integer> values) {
            addCriterion("rh_blood in", values, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andRhBloodNotIn(List<Integer> values) {
            addCriterion("rh_blood not in", values, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andRhBloodBetween(Integer value1, Integer value2) {
            addCriterion("rh_blood between", value1, value2, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andRhBloodNotBetween(Integer value1, Integer value2) {
            addCriterion("rh_blood not between", value1, value2, "rhBlood");
            return (Criteria) this;
        }

        public Criteria andVillageNameIsNull() {
            addCriterion("village_name is null");
            return (Criteria) this;
        }

        public Criteria andVillageNameIsNotNull() {
            addCriterion("village_name is not null");
            return (Criteria) this;
        }

        public Criteria andVillageNameEqualTo(String value) {
            addCriterion("village_name =", value, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameNotEqualTo(String value) {
            addCriterion("village_name <>", value, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameGreaterThan(String value) {
            addCriterion("village_name >", value, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameGreaterThanOrEqualTo(String value) {
            addCriterion("village_name >=", value, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameLessThan(String value) {
            addCriterion("village_name <", value, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameLessThanOrEqualTo(String value) {
            addCriterion("village_name <=", value, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameLike(String value) {
            addCriterion("village_name like", value, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameNotLike(String value) {
            addCriterion("village_name not like", value, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameIn(List<String> values) {
            addCriterion("village_name in", values, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameNotIn(List<String> values) {
            addCriterion("village_name not in", values, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameBetween(String value1, String value2) {
            addCriterion("village_name between", value1, value2, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageNameNotBetween(String value1, String value2) {
            addCriterion("village_name not between", value1, value2, "villageName");
            return (Criteria) this;
        }

        public Criteria andVillageTelIsNull() {
            addCriterion("village_tel is null");
            return (Criteria) this;
        }

        public Criteria andVillageTelIsNotNull() {
            addCriterion("village_tel is not null");
            return (Criteria) this;
        }

        public Criteria andVillageTelEqualTo(String value) {
            addCriterion("village_tel =", value, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelNotEqualTo(String value) {
            addCriterion("village_tel <>", value, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelGreaterThan(String value) {
            addCriterion("village_tel >", value, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelGreaterThanOrEqualTo(String value) {
            addCriterion("village_tel >=", value, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelLessThan(String value) {
            addCriterion("village_tel <", value, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelLessThanOrEqualTo(String value) {
            addCriterion("village_tel <=", value, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelLike(String value) {
            addCriterion("village_tel like", value, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelNotLike(String value) {
            addCriterion("village_tel not like", value, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelIn(List<String> values) {
            addCriterion("village_tel in", values, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelNotIn(List<String> values) {
            addCriterion("village_tel not in", values, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelBetween(String value1, String value2) {
            addCriterion("village_tel between", value1, value2, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageTelNotBetween(String value1, String value2) {
            addCriterion("village_tel not between", value1, value2, "villageTel");
            return (Criteria) this;
        }

        public Criteria andVillageAddressIsNull() {
            addCriterion("village_address is null");
            return (Criteria) this;
        }

        public Criteria andVillageAddressIsNotNull() {
            addCriterion("village_address is not null");
            return (Criteria) this;
        }

        public Criteria andVillageAddressEqualTo(String value) {
            addCriterion("village_address =", value, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressNotEqualTo(String value) {
            addCriterion("village_address <>", value, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressGreaterThan(String value) {
            addCriterion("village_address >", value, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressGreaterThanOrEqualTo(String value) {
            addCriterion("village_address >=", value, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressLessThan(String value) {
            addCriterion("village_address <", value, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressLessThanOrEqualTo(String value) {
            addCriterion("village_address <=", value, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressLike(String value) {
            addCriterion("village_address like", value, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressNotLike(String value) {
            addCriterion("village_address not like", value, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressIn(List<String> values) {
            addCriterion("village_address in", values, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressNotIn(List<String> values) {
            addCriterion("village_address not in", values, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressBetween(String value1, String value2) {
            addCriterion("village_address between", value1, value2, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressNotBetween(String value1, String value2) {
            addCriterion("village_address not between", value1, value2, "villageAddress");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishIsNull() {
            addCriterion("village_address_replenish is null");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishIsNotNull() {
            addCriterion("village_address_replenish is not null");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishEqualTo(String value) {
            addCriterion("village_address_replenish =", value, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishNotEqualTo(String value) {
            addCriterion("village_address_replenish <>", value, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishGreaterThan(String value) {
            addCriterion("village_address_replenish >", value, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishGreaterThanOrEqualTo(String value) {
            addCriterion("village_address_replenish >=", value, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishLessThan(String value) {
            addCriterion("village_address_replenish <", value, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishLessThanOrEqualTo(String value) {
            addCriterion("village_address_replenish <=", value, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishLike(String value) {
            addCriterion("village_address_replenish like", value, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishNotLike(String value) {
            addCriterion("village_address_replenish not like", value, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishIn(List<String> values) {
            addCriterion("village_address_replenish in", values, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishNotIn(List<String> values) {
            addCriterion("village_address_replenish not in", values, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishBetween(String value1, String value2) {
            addCriterion("village_address_replenish between", value1, value2, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andVillageAddressReplenishNotBetween(String value1, String value2) {
            addCriterion("village_address_replenish not between", value1, value2, "villageAddressReplenish");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdIsNull() {
            addCriterion("member_level_id is null");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdIsNotNull() {
            addCriterion("member_level_id is not null");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdEqualTo(Integer value) {
            addCriterion("member_level_id =", value, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdNotEqualTo(Integer value) {
            addCriterion("member_level_id <>", value, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdGreaterThan(Integer value) {
            addCriterion("member_level_id >", value, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("member_level_id >=", value, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdLessThan(Integer value) {
            addCriterion("member_level_id <", value, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdLessThanOrEqualTo(Integer value) {
            addCriterion("member_level_id <=", value, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdIn(List<Integer> values) {
            addCriterion("member_level_id in", values, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdNotIn(List<Integer> values) {
            addCriterion("member_level_id not in", values, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdBetween(Integer value1, Integer value2) {
            addCriterion("member_level_id between", value1, value2, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberLevelIdNotBetween(Integer value1, Integer value2) {
            addCriterion("member_level_id not between", value1, value2, "memberLevelId");
            return (Criteria) this;
        }

        public Criteria andMemberFormIsNull() {
            addCriterion("member_form is null");
            return (Criteria) this;
        }

        public Criteria andMemberFormIsNotNull() {
            addCriterion("member_form is not null");
            return (Criteria) this;
        }

        public Criteria andMemberFormEqualTo(Integer value) {
            addCriterion("member_form =", value, "memberForm");
            return (Criteria) this;
        }

        public Criteria andMemberFormNotEqualTo(Integer value) {
            addCriterion("member_form <>", value, "memberForm");
            return (Criteria) this;
        }

        public Criteria andMemberFormGreaterThan(Integer value) {
            addCriterion("member_form >", value, "memberForm");
            return (Criteria) this;
        }

        public Criteria andMemberFormGreaterThanOrEqualTo(Integer value) {
            addCriterion("member_form >=", value, "memberForm");
            return (Criteria) this;
        }

        public Criteria andMemberFormLessThan(Integer value) {
            addCriterion("member_form <", value, "memberForm");
            return (Criteria) this;
        }

        public Criteria andMemberFormLessThanOrEqualTo(Integer value) {
            addCriterion("member_form <=", value, "memberForm");
            return (Criteria) this;
        }

        public Criteria andMemberFormIn(List<Integer> values) {
            addCriterion("member_form in", values, "memberForm");
            return (Criteria) this;
        }

        public Criteria andMemberFormNotIn(List<Integer> values) {
            addCriterion("member_form not in", values, "memberForm");
            return (Criteria) this;
        }

        public Criteria andMemberFormBetween(Integer value1, Integer value2) {
            addCriterion("member_form between", value1, value2, "memberForm");
            return (Criteria) this;
        }

        public Criteria andMemberFormNotBetween(Integer value1, Integer value2) {
            addCriterion("member_form not between", value1, value2, "memberForm");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlIsNull() {
            addCriterion("portrait_url is null");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlIsNotNull() {
            addCriterion("portrait_url is not null");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlEqualTo(String value) {
            addCriterion("portrait_url =", value, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlNotEqualTo(String value) {
            addCriterion("portrait_url <>", value, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlGreaterThan(String value) {
            addCriterion("portrait_url >", value, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlGreaterThanOrEqualTo(String value) {
            addCriterion("portrait_url >=", value, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlLessThan(String value) {
            addCriterion("portrait_url <", value, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlLessThanOrEqualTo(String value) {
            addCriterion("portrait_url <=", value, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlLike(String value) {
            addCriterion("portrait_url like", value, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlNotLike(String value) {
            addCriterion("portrait_url not like", value, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlIn(List<String> values) {
            addCriterion("portrait_url in", values, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlNotIn(List<String> values) {
            addCriterion("portrait_url not in", values, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlBetween(String value1, String value2) {
            addCriterion("portrait_url between", value1, value2, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andPortraitUrlNotBetween(String value1, String value2) {
            addCriterion("portrait_url not between", value1, value2, "portraitUrl");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeIsNull() {
            addCriterion("lssued_office is null");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeIsNotNull() {
            addCriterion("lssued_office is not null");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeEqualTo(String value) {
            addCriterion("lssued_office =", value, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeNotEqualTo(String value) {
            addCriterion("lssued_office <>", value, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeGreaterThan(String value) {
            addCriterion("lssued_office >", value, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeGreaterThanOrEqualTo(String value) {
            addCriterion("lssued_office >=", value, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeLessThan(String value) {
            addCriterion("lssued_office <", value, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeLessThanOrEqualTo(String value) {
            addCriterion("lssued_office <=", value, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeLike(String value) {
            addCriterion("lssued_office like", value, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeNotLike(String value) {
            addCriterion("lssued_office not like", value, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeIn(List<String> values) {
            addCriterion("lssued_office in", values, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeNotIn(List<String> values) {
            addCriterion("lssued_office not in", values, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeBetween(String value1, String value2) {
            addCriterion("lssued_office between", value1, value2, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andLssuedOfficeNotBetween(String value1, String value2) {
            addCriterion("lssued_office not between", value1, value2, "lssuedOffice");
            return (Criteria) this;
        }

        public Criteria andCardValidDateIsNull() {
            addCriterion("card_valid_date is null");
            return (Criteria) this;
        }

        public Criteria andCardValidDateIsNotNull() {
            addCriterion("card_valid_date is not null");
            return (Criteria) this;
        }

        public Criteria andCardValidDateEqualTo(Date value) {
            addCriterionForJDBCDate("card_valid_date =", value, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andCardValidDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("card_valid_date <>", value, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andCardValidDateGreaterThan(Date value) {
            addCriterionForJDBCDate("card_valid_date >", value, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andCardValidDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("card_valid_date >=", value, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andCardValidDateLessThan(Date value) {
            addCriterionForJDBCDate("card_valid_date <", value, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andCardValidDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("card_valid_date <=", value, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andCardValidDateIn(List<Date> values) {
            addCriterionForJDBCDate("card_valid_date in", values, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andCardValidDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("card_valid_date not in", values, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andCardValidDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("card_valid_date between", value1, value2, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andCardValidDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("card_valid_date not between", value1, value2, "cardValidDate");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberIsNull() {
            addCriterion("ic_card_number is null");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberIsNotNull() {
            addCriterion("ic_card_number is not null");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberEqualTo(String value) {
            addCriterion("ic_card_number =", value, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberNotEqualTo(String value) {
            addCriterion("ic_card_number <>", value, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberGreaterThan(String value) {
            addCriterion("ic_card_number >", value, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberGreaterThanOrEqualTo(String value) {
            addCriterion("ic_card_number >=", value, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberLessThan(String value) {
            addCriterion("ic_card_number <", value, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberLessThanOrEqualTo(String value) {
            addCriterion("ic_card_number <=", value, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberLike(String value) {
            addCriterion("ic_card_number like", value, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberNotLike(String value) {
            addCriterion("ic_card_number not like", value, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberIn(List<String> values) {
            addCriterion("ic_card_number in", values, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberNotIn(List<String> values) {
            addCriterion("ic_card_number not in", values, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberBetween(String value1, String value2) {
            addCriterion("ic_card_number between", value1, value2, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcCardNumberNotBetween(String value1, String value2) {
            addCriterion("ic_card_number not between", value1, value2, "icCardNumber");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierIsNull() {
            addCriterion("ic_identifier is null");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierIsNotNull() {
            addCriterion("ic_identifier is not null");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierEqualTo(String value) {
            addCriterion("ic_identifier =", value, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierNotEqualTo(String value) {
            addCriterion("ic_identifier <>", value, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierGreaterThan(String value) {
            addCriterion("ic_identifier >", value, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierGreaterThanOrEqualTo(String value) {
            addCriterion("ic_identifier >=", value, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierLessThan(String value) {
            addCriterion("ic_identifier <", value, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierLessThanOrEqualTo(String value) {
            addCriterion("ic_identifier <=", value, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierLike(String value) {
            addCriterion("ic_identifier like", value, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierNotLike(String value) {
            addCriterion("ic_identifier not like", value, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierIn(List<String> values) {
            addCriterion("ic_identifier in", values, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierNotIn(List<String> values) {
            addCriterion("ic_identifier not in", values, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierBetween(String value1, String value2) {
            addCriterion("ic_identifier between", value1, value2, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andIcIdentifierNotBetween(String value1, String value2) {
            addCriterion("ic_identifier not between", value1, value2, "icIdentifier");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("password is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("password is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("password =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("password <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("password >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("password >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("password <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("password <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("password like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("password not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("password in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("password not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("password between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("password not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(String value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(String value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(String value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(String value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLike(String value) {
            addCriterion("create_by like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotLike(String value) {
            addCriterion("create_by not like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<String> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<String> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(String value1, String value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("update_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("update_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(String value) {
            addCriterion("update_by =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(String value) {
            addCriterion("update_by <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(String value) {
            addCriterion("update_by >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("update_by >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(String value) {
            addCriterion("update_by <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("update_by <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLike(String value) {
            addCriterion("update_by like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotLike(String value) {
            addCriterion("update_by not like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<String> values) {
            addCriterion("update_by in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<String> values) {
            addCriterion("update_by not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(String value1, String value2) {
            addCriterion("update_by between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("update_by not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andNationalityIsNull() {
            addCriterion("nationality is null");
            return (Criteria) this;
        }

        public Criteria andNationalityIsNotNull() {
            addCriterion("nationality is not null");
            return (Criteria) this;
        }

        public Criteria andNationalityEqualTo(String value) {
            addCriterion("nationality =", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityNotEqualTo(String value) {
            addCriterion("nationality <>", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityGreaterThan(String value) {
            addCriterion("nationality >", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityGreaterThanOrEqualTo(String value) {
            addCriterion("nationality >=", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityLessThan(String value) {
            addCriterion("nationality <", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityLessThanOrEqualTo(String value) {
            addCriterion("nationality <=", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityLike(String value) {
            addCriterion("nationality like", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityNotLike(String value) {
            addCriterion("nationality not like", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityIn(List<String> values) {
            addCriterion("nationality in", values, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityNotIn(List<String> values) {
            addCriterion("nationality not in", values, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityBetween(String value1, String value2) {
            addCriterion("nationality between", value1, value2, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityNotBetween(String value1, String value2) {
            addCriterion("nationality not between", value1, value2, "nationality");
            return (Criteria) this;
        }

        public Criteria andIsMarriedIsNull() {
            addCriterion("is_married is null");
            return (Criteria) this;
        }

        public Criteria andIsMarriedIsNotNull() {
            addCriterion("is_married is not null");
            return (Criteria) this;
        }

        public Criteria andIsMarriedEqualTo(Integer value) {
            addCriterion("is_married =", value, "isMarried");
            return (Criteria) this;
        }

        public Criteria andIsMarriedNotEqualTo(Integer value) {
            addCriterion("is_married <>", value, "isMarried");
            return (Criteria) this;
        }

        public Criteria andIsMarriedGreaterThan(Integer value) {
            addCriterion("is_married >", value, "isMarried");
            return (Criteria) this;
        }

        public Criteria andIsMarriedGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_married >=", value, "isMarried");
            return (Criteria) this;
        }

        public Criteria andIsMarriedLessThan(Integer value) {
            addCriterion("is_married <", value, "isMarried");
            return (Criteria) this;
        }

        public Criteria andIsMarriedLessThanOrEqualTo(Integer value) {
            addCriterion("is_married <=", value, "isMarried");
            return (Criteria) this;
        }

        public Criteria andIsMarriedIn(List<Integer> values) {
            addCriterion("is_married in", values, "isMarried");
            return (Criteria) this;
        }

        public Criteria andIsMarriedNotIn(List<Integer> values) {
            addCriterion("is_married not in", values, "isMarried");
            return (Criteria) this;
        }

        public Criteria andIsMarriedBetween(Integer value1, Integer value2) {
            addCriterion("is_married between", value1, value2, "isMarried");
            return (Criteria) this;
        }

        public Criteria andIsMarriedNotBetween(Integer value1, Integer value2) {
            addCriterion("is_married not between", value1, value2, "isMarried");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEnableIsNull() {
            addCriterion("enable is null");
            return (Criteria) this;
        }

        public Criteria andEnableIsNotNull() {
            addCriterion("enable is not null");
            return (Criteria) this;
        }

        public Criteria andEnableEqualTo(Integer value) {
            addCriterion("enable =", value, "enable");
            return (Criteria) this;
        }

        public Criteria andEnableNotEqualTo(Integer value) {
            addCriterion("enable <>", value, "enable");
            return (Criteria) this;
        }

        public Criteria andEnableGreaterThan(Integer value) {
            addCriterion("enable >", value, "enable");
            return (Criteria) this;
        }

        public Criteria andEnableGreaterThanOrEqualTo(Integer value) {
            addCriterion("enable >=", value, "enable");
            return (Criteria) this;
        }

        public Criteria andEnableLessThan(Integer value) {
            addCriterion("enable <", value, "enable");
            return (Criteria) this;
        }

        public Criteria andEnableLessThanOrEqualTo(Integer value) {
            addCriterion("enable <=", value, "enable");
            return (Criteria) this;
        }

        public Criteria andEnableIn(List<Integer> values) {
            addCriterion("enable in", values, "enable");
            return (Criteria) this;
        }

        public Criteria andEnableNotIn(List<Integer> values) {
            addCriterion("enable not in", values, "enable");
            return (Criteria) this;
        }

        public Criteria andEnableBetween(Integer value1, Integer value2) {
            addCriterion("enable between", value1, value2, "enable");
            return (Criteria) this;
        }

        public Criteria andEnableNotBetween(Integer value1, Integer value2) {
            addCriterion("enable not between", value1, value2, "enable");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}